Retirement Planning Simulation


Kerry Back

BUSI 721, Fall 2022
JGSB, Rice University

Example

R = 30*12      # 30 years until retirement
T = 60*12      # 60 total years
g = 0.002      # deposit is 0.2% larger each month
B0 = 100000    # initial balance is $100,000
D1 = 1000      # initial savings is $1,000 (per month)
W = 10000      # withdraw $10,000 per month in retirement

mn = 0.005     # mean monthly return
sd = 0.04      # std dev of monthly return
nsims = 1000   # number of simulated

Distribution of ending balances

Distribution of ending balances

mean    1.250549e+06
std     1.061159e+07
min    -1.768985e+07
10%    -5.459511e+06
25%    -3.479901e+06
50%    -1.312272e+06
75%     2.701016e+06
90%     9.687868e+06
max     1.334897e+08
dtype: float64

HTML tutorial